package cn.edu.kzjsxy.graduationproject.mapper;

import cn.edu.kzjsxy.graduationproject.dto.StudentDormitoryAssignment;
import cn.edu.kzjsxy.graduationproject.entity.StudentDormAssignments;
import cn.edu.kzjsxy.graduationproject.entity.Users;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * <p>
 * 学生宿舍分配表 Mapper 接口
 * </p>
 *
 * @author chén jiā jùn
 * @since 2024-04-14
 */
@Mapper
public interface StudentDormAssignmentsMapper extends BaseMapper<StudentDormAssignments> {

//	根据条件查询学生宿舍分配信息
	List<StudentDormAssignments> selectStudentDormAssignmentsByCondition(StudentDormAssignments studentDormAssignments);

//	查询学生宿舍分配信息 (多表查询)
	List<StudentDormitoryAssignment> getStudentDormAssignments(StudentDormitoryAssignment studentDormitoryAssignment);

//  查询未分配的学生信息（多表查询）
	List<Users> getStudentsWithoutDormitory();
}
